//package com.xiguaji.tiktok.task.blogger.repository;
//
//import com.gugee.tiktok.common.model.dto.SlimBloggerDto;
//import com.gugee.tiktok.common.model.mysql.Blogger;
//import org.springframework.data.jdbc.repository.query.Query;
//import org.springframework.data.repository.CrudRepository;
//import org.springframework.stereotype.Repository;
//
//import java.util.List;
//import java.util.Optional;
//
//@Repository
//public interface BloggerRepository extends CrudRepository<Blogger, Long>, BloggerExtRepository {
//    Optional<Blogger> findByoUid(long oUid);
//
//    @Query("SELECT id,o_uid as uid,o_region as region FROM blogger " +
//            "WHERE id > :id " +
//            "AND o_region != 'IN'"+
//            "ORDER BY id ASC " +
//            "LIMIT :count")
//    List<SlimBloggerDto> findSlimBloggersByIdAndCount(long id, int count);
//    @Query("SELECT * FROM blogger " +
//            "WHERE id>:id AND o_follower_count >= :oFollowerCount  " +
////            "WHERE o_follower_count > :oFollowerCount AND  o_follower_count <:20000" +
//            "AND o_region != 'IN' "+
//            "ORDER BY id ASC " +
//            "LIMIT 0,:count")
//    List<Blogger> findSlimBloggersByIdAndCount(int oFollowerCount,long id,long count);
//    List<Blogger> findTop2000ByoFollowerCountGreaterThanAndIdGreaterThanOrderByIdAsc(int oFollowerCount, long id);
//
//
//    boolean existsByoUid(long oUid);
//}
